SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateGwyNews]
    (
      @JOL_EmployerName VARCHAR(50),
      @JOL_GWY_NewsTitle VARCHAR(50),
      @JOL_GWY_NewsBody NTEXT,
      @JOL_GWY_ApplyMethod VARCHAR(50),
      @JOL_GWY_UpdateUser VARCHAR(50),
      @JOL_GWY_UpdateTime DATETIME,
      @JOL_GWY_News_ID INT
    )
AS 
    UPDATE  dbo.JOL_GWY_News
    SET     JOL_EmployerName = @JOL_EmployerName,
            JOL_GWY_NewsTitle = @JOL_GWY_NewsTitle,
            JOL_GWY_NewsBody = @JOL_GWY_NewsBody,
            JOL_GWY_ApplyMethod = @JOL_GWY_ApplyMethod,
            JOL_GWY_UpdateUser = @JOL_GWY_UpdateUser,
            JOL_GWY_UpdateTime = GETDATE()
    WHERE   JOL_GWY_News_ID = @JOL_GWY_News_ID

GO
